Tips on creating databases, creating SQL queries using Alpha Anywhere's Portable SQL Syntax, using the SQL command window, and more.

Pointer arrays (also called "property arrays") allow you to represent "multi-columned" data in an array. For example, for a customer, you have information about the customer's name, address, phone number etc.

There are 2 different approaches to building a SQL Report.

Reports, Letters, and Labels are Alpha Anywhere layouts for data output. Learn how to create reports in this guide.

In this lesson, you learn how to view and enter data in Alpha Anywhere, and how to create, change, save, and delete table records.

Using Xbasic, you can manipulate data in variables and in RTF memo fields. In order to manipulate a RTF memo field, you need to create a temporary RTF object, manipulate its contents, and then put the contents of the temporary RTF object back into the RTF memo field. The RTF.CREATE() method is used to create a RTF object. Refer to RTF Functions and Methods for more information.

Tables, sets, and workspaces are the primary structures for storing data in an Alpha Anywhere desktop applications. Your workspace files keep track of all of the tables, sets, toolbars, forms, and such, used for managing information. When you open an existing workspace, Alpha Anywhere displays the objects (tables, forms, etc.) that make up the workspace in the Control Panel. With Alpha Anywhere, you work with one workspace at a time.

It easy to integrate your Alpha Anywhere coding with external version control systems. Most version control systems depend on storing the small differences between successive versions of text files for efficient storage. Most Alpha Anywhere artifacts are normally stored in a binary database or a binary file for efficient loading and saving. This has historically presented an "impedance mismatch" between Alpha Anywhere code and version control systems. To address this, we have introduced the option to keep a project's code in an external file system.

A guide to using auto-increment in Oracle.